/*
 Navicat Premium Data Transfer

 Source Server         : jf本地
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : jf

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 10/06/2023 19:38:11
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for bazi
-- ----------------------------
DROP TABLE IF EXISTS `bazi`;
CREATE TABLE `bazi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `location` varchar(100) NOT NULL DEFAULT '',
  `sex` int(11) NOT NULL COMMENT '男女',
  `islunar` int(11) NOT NULL COMMENT '阴历',
  `realtime` int(11) NOT NULL COMMENT '真太阳时',
  `lunardate` varchar(50) NOT NULL DEFAULT '' COMMENT '阴历时间',
  `solardate` varchar(50) NOT NULL DEFAULT '' COMMENT '阳历时间',
  `bazi` varchar(50) NOT NULL DEFAULT '' COMMENT '八字',
  `createtime` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for fenhui
-- ----------------------------
DROP TABLE IF EXISTS `fenhui`;
CREATE TABLE `fenhui` (
  `id` int(11) DEFAULT NULL,
  `user` varchar(50) DEFAULT NULL,
  `tel` varchar(50) DEFAULT NULL,
  `location` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for fhplan
-- ----------------------------
DROP TABLE IF EXISTS `fhplan`;
CREATE TABLE `fhplan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` varchar(50) NOT NULL DEFAULT '',
  `contact` varchar(50) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for member
-- ----------------------------
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `p_id` bigint(20) DEFAULT NULL,
  `score` int(20) NOT NULL DEFAULT '0',
  `username` varchar(50) NOT NULL DEFAULT '',
  `tel` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for plan
-- ----------------------------
DROP TABLE IF EXISTS `plan`;
CREATE TABLE `plan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `date` varchar(50) NOT NULL,
  `edate` varchar(50) DEFAULT NULL,
  `username` varchar(50) NOT NULL,
  `uid` bigint(20) NOT NULL,
  `location` varchar(100) DEFAULT NULL,
  `action` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=696 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of plan
-- ----------------------------
BEGIN;
INSERT INTO `plan` VALUES (688, '2023-06-01', '2023-06-02', '付焕思', 1, '菏泽', '讲课');
INSERT INTO `plan` VALUES (689, '2023-06-08', '2023-06-11', '苏堪斌', 2, '菏泽', '环境布局');
INSERT INTO `plan` VALUES (690, '2023-06-13', '2023-06-15', '朱继涛', 3, '莱阳', '堪舆');
INSERT INTO `plan` VALUES (691, '2023-06-14', '2023-07-26', '付焕思', 1, '莱阳', '讲课');
INSERT INTO `plan` VALUES (692, '2023-06-10', '2023-06-10', '朱继涛', 3, '菏泽', '讲课');
INSERT INTO `plan` VALUES (693, '2023-06-10', '2023-06-11', '付焕思', 1, '菏泽', '堪舆');
INSERT INTO `plan` VALUES (694, '2023-06-11', '2023-06-11', '苏堪斌', 2, '莱阳', '讲课');
COMMIT;

-- ----------------------------
-- Table structure for plan_user
-- ----------------------------
DROP TABLE IF EXISTS `plan_user`;
CREATE TABLE `plan_user` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `username` varchar(50) NOT NULL DEFAULT '' COMMENT '用户名',
  `pwd` varchar(50) DEFAULT NULL,
  `unit` varchar(50) NOT NULL DEFAULT '' COMMENT '晟方国学',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='计划小程序_用户';

-- ----------------------------
-- Records of plan_user
-- ----------------------------
BEGIN;
INSERT INTO `plan_user` VALUES (0, 'admin', '123456', '晟方国学');
INSERT INTO `plan_user` VALUES (1, '旭东老师', '123456', '旭东书院');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
